USE NutritionTracker
GO
IF EXISTS (SELECT 1 FROM sysobjects WHERE ID = object_id(N'AppUser_Read_Item') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
	DROP PROCEDURE AppUser_Read_Item
GO
CREATE PROC AppUser_Read_Item
(
@AppUserID	INT
)
AS
BEGIN
	SET NOCOUNT ON

	SELECT		AppUserID,
			FirstName,
			LastName,
			EmailAddress,
			[Password],
			TimeZoneOffset,
			Approved,
			UpdatePassword,
			Deleted
	FROM		AppUser
	WHERE		AppUserID = @AppUserID			

	SET NOCOUNT OFF
END
GO
GRANT EXECUTE ON AppUser_Read_Item TO NUTRKR_WEB
GO